home *** CD-ROM | disk | FTP | other *** search
/ Cream of the Crop 1 / Cream of the Crop 1.iso / BUSINESS / SAS50.ARJ / FILES.CLA < prev    next >
Text File  |  1991-06-06  |  5KB  |  171 lines
  1. CLIENTS         FILE,PRE(CLI),CREATE,RECLAIM
  2. CLIENT_KEY     KEY(CLI:CLIENT),DUP,NOCASE,OPT
  3. ZIP_KEY           KEY(CLI:ZIP),DUP,NOCASE,OPT
  4. COMMENTS       MEMO(490)             !Comments
  5. RECORD           RECORD
  6. CLIENT         STRING(32)             !Client Name
  7. ORDEREDBY     STRING(32)             !Ordered By
  8. ADD1         STRING(32)             !Address #1
  9. ADD2         STRING(32)             !Address #2
  10. CITY         STRING(17)             !City
  11. STATE         STRING(3)             !State
  12. ZIP         STRING(10)             !Zip Code
  13. DAYPHONE     DECIMAL(10,0)             !Day Phone
  14. EXTENSION     STRING(10)             !Extension
  15. EVEPHONE     DECIMAL(10,0)             !Eve Phone
  16. FAXPHONE     DECIMAL(10,0)             !Fax Phone
  17. PRICECLASS     BYTE                 !Price Class
  18.          . .
  19.          GROUP,OVER(CLI:COMMENTS)
  20. CLI_MEMO_ROW   STRING(70),DIM(7)
  21.          .
  22.  
  23. INVNTORY     FILE,PRE(INV),CREATE,RECLAIM
  24. BY_GROUP       KEY(INV:GROUPNAME,INV:PARTNUM),NOCASE,OPT
  25. BY_PARTNUM     KEY(INV:PARTNUM),NOCASE,OPT
  26. BY_VENDOR      KEY(INV:VENDOR,INV:GROUPNAME,INV:PARTNUM),DUP,NOCASE,OPT
  27. COMMENTS       MEMO(108)             !Printable Comments
  28. RECORD           RECORD
  29. PARTNUM         STRING(16)             !Part Number
  30. GROUPNAME     STRING(10)             !Group Name
  31. PRODDESC     STRING(27)             !Product Description
  32. COST         REAL                 !Item Cost
  33. MFGRETAIL     REAL                 !MFG Retail Price
  34. CLASS1         REAL                 !Price Class 1
  35. CLASS2         REAL                 !Price Class 2
  36. CLASS3         REAL                 !Price Class 3
  37. STOCK_ADJUST     STRING(3)             !Adjust Stock on Sold Items?
  38. TAXABLE         STRING(3)             !Taxable Flag
  39. VENDOR         STRING(32)             !Vendor Name
  40. NOTES1         STRING(27)             !Non-Print #1
  41. NOTES2         STRING(27)
  42. NOTES3         STRING(27)
  43. NOTES4         STRING(27)
  44. ON_HAND         REAL                 !Qty On Hand
  45. ON_ORDER     REAL                 !Qty On Order
  46. MIN_QTY         REAL                 !Minimum Quantity
  47.          . .
  48.          GROUP,OVER(INV:COMMENTS)
  49. INV_MEMO_ROW   STRING(27),DIM(4)
  50.          .
  51.  
  52. ORDERS         FILE,PRE(ORD),CREATE,RECLAIM
  53. ORDER_KEY      KEY(ORD:ORDER_NUM),NOCASE,OPT
  54. TYPE_KEY       KEY(ORD:TYPE,ORD:CLIENT,ORD:DATE),DUP,NOCASE,OPT
  55. TYPE_DATE      KEY(ORD:TYPE,ORD:DATE),DUP,NOCASE,OPT
  56. NOTES           MEMO(87)                 !Order Notes
  57. RECORD           RECORD
  58. ORDER_NUM     LONG                 !Order Number
  59. INVOICE_NUM     LONG                 !Invoice #
  60. INV_ADJUSTED     STRING(1)             !Inventory Adjusted?
  61. CLIENT         STRING(32)             !Client Name
  62. TYPE         STRING(9)             !Order Type
  63. DATE         LONG                 !Order Date
  64. SALESPERSON     STRING(32)             !Salesperson
  65. ORDERREF     STRING(28)             !Order Reference
  66. PRICECLASS     BYTE                 !Price Class
  67. TAXPCT         REAL                 !Tax Percentage
  68. TAX         REAL                 !Tax on Order
  69. PAYMETHOD     STRING(20)             !Method of Payment
  70. TERMS         STRING(13)             !Payment Terms
  71. PO         STRING(25)             !Purchase Order Number
  72. CCNUM         STRING(25)             !Credit Card Number
  73. EXPDATE         STRING(10)             !Credit Card Expiration Date
  74. AUTHORIZE     STRING(12)             !CC Authorization
  75. SURCHARGE     REAL                 !Credit Card Surcharge
  76. SHIPTO         STRING(32)             !Ship To - Name
  77. SHIPADD1     STRING(32)             !Ship To - Address #1
  78. SHIPADD2     STRING(32)             !Ship To - Address #2
  79. SHIPCITY     STRING(17)             !Ship To - City
  80. SHIPSTATE     STRING(3)             !Ship To - State
  81. SHIPZIP         STRING(10)             !Ship To - Zip Code
  82. SHIPATTN     STRING(26)             !Ship To - Attention
  83. COST         REAL                 !Order Cost
  84. SUBTOTAL     REAL                 !Order Subtotal
  85. TAXABLE         REAL
  86.          . .
  87.          GROUP,OVER(ORD:NOTES)
  88. ORD_MEMO_ROW   STRING(29),DIM(3)
  89.          .
  90.  
  91. ITEM_ORD     FILE,PRE(ITE),CREATE
  92. ORD_KEY           KEY(ITE:ORDER_NUM),DUP,NOCASE,OPT
  93. RECORD           RECORD
  94. ORDER_NUM     LONG                 !Order Number
  95. PART_NUM     STRING(16)             !Part Number
  96. QTY         LONG                 !Quantity
  97. UNITCOST     REAL                 !Unit Cost
  98. PRODDESC     STRING(27)             !Product Description
  99. ORDERPRICE     REAL                 !Order Price
  100.          . .
  101.  
  102. PAYMETHD     FILE,PRE(PAY),CREATE,RECLAIM
  103. METHOD_KEY     KEY(PAY:METHOD_PAY),NOCASE,OPT
  104. RECORD           RECORD
  105. METHOD_PAY     STRING(20)             !Method Of Payment
  106.          . .
  107.  
  108. TERMS         FILE,PRE(TER),CREATE,RECLAIM
  109. TERM_KEY       KEY(TER:TERMS),NOCASE,OPT
  110. RECORD           RECORD
  111. TERMS         STRING(13)             !Terms of Order
  112.          . .
  113.  
  114. VENDORS         FILE,PRE(VEN),CREATE,RECLAIM
  115. VEN_KEY           KEY(VEN:VENDOR),DUP,NOCASE,OPT
  116. VEN_NUM_KEY    KEY(VEN:VENDOR_NUM),NOCASE,OPT
  117. ZIP_KEY           KEY(VEN:ZIP),DUP,NOCASE,OPT
  118. COMMENTS       MEMO(350)             !Comments
  119. RECORD           RECORD
  120. VENDOR_NUM     LONG
  121. VENDOR         STRING(32)             !Vendor Name
  122. ADD1         STRING(32)             !Address #1
  123. ADD2         STRING(32)             !Address #2
  124. CITY         STRING(17)             !City
  125. STATE         STRING(3)             !State
  126. ZIP         STRING(10)             !Zip Code
  127. CONTACT         STRING(32)             !Contact Person
  128. DAYPHONE     DECIMAL(10,0)             !Phone Number
  129. EXTENSION     STRING(10)             !Extension
  130. EVEPHONE     DECIMAL(10,0)             !Phone Number #2
  131. FAXPHONE     DECIMAL(10,0)             !Fax Phone Number
  132. ACCTNUM         STRING(20)             !Account Number
  133. TERMS         STRING(32)             !Terms
  134.          . .
  135.          GROUP,OVER(VEN:COMMENTS)
  136. VEN_MEMO_ROW   STRING(70),DIM(5)
  137.          .
  138.  
  139. COMPANY         FILE,PRE(COM),CREATE,RECLAIM
  140. RECORD           RECORD
  141. COMPANY         STRING(32)
  142. ADD1         STRING(32)
  143. ADD2         STRING(32)
  144. CITY         STRING(17)
  145. STATE         STRING(3)
  146. ZIP         STRING(10)
  147. PHONE         STRING(14)
  148. TAXPCT         REAL
  149. INVOICE_NUM     LONG
  150. COM1         STRING(60)
  151. COM2         STRING(60)
  152. COM3         STRING(60)
  153. FIN3         DECIMAL(10,10)
  154. TIMEFIN3     STRING(5)
  155. FIN4         DECIMAL(10,10)
  156. TIMEFIN4     STRING(5)
  157. FIN5         DECIMAL(10,10)
  158. TIMEFIN5     STRING(5)
  159. C1MARGIN     REAL                 !Class 1 Default Margin
  160. C2MARGIN     REAL                 !Class 2 Default Margin
  161. C3MARGIN     REAL                 !Class 3 Default MArgin
  162. PRINTER         STRING(5)
  163.          . .
  164.  
  165. SALESPER     FILE,PRE(SAL),CREATE,RECLAIM
  166. SALES_KEY      KEY(SAL:SALESPERSON),NOCASE,OPT
  167. RECORD           RECORD
  168. SALESPERSON     STRING(32)             !Salesperson Name
  169.          . .
  170.  
  171.